<?xml version="1.0" encoding="utf-8"?>
<Query Version="V02" QueryName="PropertyQuery">
  <Columns>
    <ColumnName>KDOR_vwPropertyGeneral.CountyCode</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.PropertyID</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.AdHocTaxYear</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.QuickRefID</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.PropertyNumber</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.PropertyAddress</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.fpropclass</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.TaxingUnitGroupCode</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.TaxingUnitGroupDesc</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.flbcsfunc</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.vproplevel_TotAgAcres</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.vproplevel_TotAgMktValue</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.vproplevel_TotAgUseValue</ColumnName>
    <ColumnName>vwPropertyOwner.PartyName</ColumnName>
    <ColumnName>vwPropertyOwner.PartyAddress</ColumnName>
    <ColumnName>vwPartyAddress.State</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.LegalLocationCode</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.LegalLocationDesc</ColumnName>
    <ColumnName>app_vPropertyLegal.TownshipSection</ColumnName>
    <ColumnName>app_vPropertyLegal.Township</ColumnName>
    <ColumnName>app_vPropertyLegal.TownshipRange</ColumnName>
    <ColumnName>app_vPropertyLegal.SubBlock</ColumnName>
    <ColumnName>app_vPropertyLegal.SubLot</ColumnName>
    <ColumnName>app_vPropertyLegal.SubLotRange</ColumnName>
    <ColumnName>app_vPropertyLegal.LegalMiscInfoText</ColumnName>
  </Columns>
  <Tables>
    <TableName>app_vPropertyLegal</TableName>
    <TableName>vwPropertyOwner</TableName>
    <TableName>vwPartyAddress</TableName>
  </Tables>
  <ActiveOnly>true</ActiveOnly>
  <Distinct>false</Distinct>
  <GroupBy>false</GroupBy>
  <Criteria>
    <ColumnName>KDOR_vwPropertyGeneral.AdHocTaxYear</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>2015</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>KDOR_vwPropertyGeneral.vproplevel_TotAgAcres</ColumnName>
    <Not>false</Not>
    <Test>Greater Than</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>0</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>vwPropertyOwner.PrimaryOwner</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>1</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>vwPartyAddress.DefaultAddress</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>1</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Output>CSV</Output>
</Query>